<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title>data_size_per_engine: common_schema documentation</title>
	<meta name="description" content="data_size_per_engine: common_schema" />
	<meta name="keywords" content="data_size_per_engine: common_schema" />
	<link rel="stylesheet" type="text/css" href="css/style.css" />
</head>

<body>
	<div id="main">
		<div id="header">
			<h1>common_schema</h1> <strong>2.2</strong> documentation
			<div class="subtitle">DBA's framework for MySQL</div>
		</div>
		<div id="contentwrapper">
			<div id="content">
				<h2><a href="data_size_per_engine.html">data_size_per_engine</a></h2>	
<h3>NAME</h3>
data_size_per_engine: Present with data size measurements per storage engine
<h3>TYPE</h3>
View

<h3>DESCRIPTION</h3>

<p><i>data_size_per_engine</i> provides with an approximate data size in bytes per storage engine. 
It is useful in diagnosing an unfamiliar server, checking up on the different defined engines and the volumes they hold. 
</p>

<p>This view includes dimensions of the <strong>`mysql`</strong> schema, since this schema may also include user data such as stored routines.
It does not consider INFORMATION_SCHEMA nor PERFORMANCE_SCHEMA.
</p>

<h3>STRUCTURE</h3>

<blockquote><pre>
mysql&gt; DESC common_schema.data_size_per_engine;
+--------------------+---------------------+------+-----+---------+-------+
| Field              | Type                | Null | Key | Default | Extra |
+--------------------+---------------------+------+-----+---------+-------+
| ENGINE             | varchar(64)         | YES  |     | NULL    |       |
| count_tables       | bigint(21)          | NO   |     | 0       |       |
| data_size          | decimal(42,0)       | YES  |     | NULL    |       |
| index_size         | decimal(42,0)       | YES  |     | NULL    |       |
| total_size         | decimal(43,0)       | YES  |     | NULL    |       |
| largest_table      | longtext            | YES  |     | NULL    |       |
| largest_table_size | bigint(20) unsigned | YES  |     | NULL    |       |
+--------------------+---------------------+------+-----+---------+-------+
</pre></blockquote>

<h3>SYNOPSIS</h3>

<p>Columns of this view:</p>
<ul>
	<li><strong>ENGINE</strong>: name of storage engine</li>
	<li><strong>count_tables</strong>: number of tables of this engine</li>
	<li><strong>data_size</strong>: approximate data size in bytes for all tables of this engine</li>
	<li><strong>index_size</strong>: approximate index size in bytes for all tables of this engine</li>
	<li><strong>total_size</strong>: sum of data_size and index_size: approximate total size on disk</li>
	<li><strong>largest_table</strong>: fully qualified name of largest table of this engine</li>
	<li><strong>largest_table_size</strong>: total size in bytes of largest_table</li>
</ul>

<h3>EXAMPLES</h3>
<p>Show dimensions per storage engine on an InnoDB-dedicated server:</p>
<blockquote><pre>mysql&gt; SELECT * FROM common_schema.data_size_per_engine;
+--------+--------------+--------------+-------------+--------------+---------------------------+--------------------+
| ENGINE | count_tables | data_size    | index_size  | total_size   | largest_table             | largest_table_size |
+--------+--------------+--------------+-------------+--------------+---------------------------+--------------------+
| CSV    |            2 |            0 |           0 |            0 | `mysql`.`general_log`     |                  0 |
| InnoDB |          172 | 252877864960 | 68769677312 | 321647542272 | `webdata`.`data_archive`  |       150358507520 |
| MyISAM |           21 |       573493 |       95232 |       668725 | `mysql`.`help_topic`      |             442472 |
| SPHINX |            1 |            0 |           0 |            0 | `webdata`.`sphinx_search` |                  0 |
+--------+--------------+--------------+-------------+--------------+---------------------------+--------------------+
</pre></blockquote>
<p>In the above example the only MyISAM tables are those of the <strong>`mysql`</strong> schema.</p>

<h3>ENVIRONMENT</h3>
MySQL 5.1 or newer

<h3>SEE ALSO</h3>
<a href="auto_increment_columns.html">auto_increment_columns</a>,
<a href="data_size_per_schema.html">data_size_per_schema</a>
<h3>AUTHOR</h3>
Shlomi Noach
				<br/>
			</div>
			<div id="sidebarwrapper">
				<div id="search">
					Search online documentation
					<form id="search_form" name="search_form" method="GET" 
						action="http://www.google.com/search" 
						onsubmit="document.forms['search_form']['q'].value = 'site:http://common-schema.googlecode.com/svn/trunk/common_schema/doc/html/ '+document.forms['search_form']['search_term'].value;">
						<input type="text" name="search_term" value=""/>
						<input type="hidden" name="q" value=""/>
						<input type="submit" value="go"/>						
					</form>
				</div>
				<div id="menu">
					<ul>
						<li><a title="Introduction" href="introduction.html">Introduction</a></li>
						<li><a title="Documentation" href="documentation.html">Documentation</a></li>
						<li><a title="Download" href="download.html">Download</a></li>
						<li><a title="Install" href="install.html">Install</a></li>
						<li><a title="Risks" href="risks.html">Risks</a></li>
					</ul>						
					<h3>QUERY SCRIPT</h3>
					<ul>
						<li><a title="QueryScript" href="query_script.html">QueryScript</a></li>
						<li><a title="Execution" href="query_script_execution.html">Execution</a></li>
						<li><a title="Flow control" href="query_script_flow_control.html">Flow control</a></li>
						<li><a title="Statements" href="query_script_statements.html">Statements</a></li>
						<li><a title="Expressions" href="query_script_expressions.html">Expressions</a></li>
						<li><a title="Variables" href="query_script_variables.html">Variables</a></li>
					</ul>						
					<h3>DEBUG</h3>
					<ul>
						<li><a title="rdebug" href="rdebug.html">rdebug</a></li>
						<li><a title="rdebug API" href="rdebug_api.html">rdebug API</a></li>
						<li><a title="rdebug workflow" href="rdebug_workflow.html">Workflow</a></li>
					</ul>						
					<h3>ROUTINES</h3>
					<ul>
						<li><a title="Execution &amp; flow control" href="execution_routines.html">Execution & flow control</a></li>
						<li><a title="General" href="general_routines.html">General</a></li>
						<li><a title="Process" href="process_routines.html">Process</a></li>
						<li><a title="Query analysis" href="query_analysis_routines.html">Query analysis</a></li>
						<li><a title="Schema analysis" href="schema_analysis_routines.html">Schema analysis</a></li>
						<li><a title="Security" href="security_routines.html">Security</a></li>
						<li><a title="Text" href="text_routines.html">Text</a></li>
						<li><a title="Time &amp; date" href="temporal_routines.html">Time & date</a></li>
						<li><a title="Charting" href="charting_routines.html">Charting</a></li>
					</ul>
					<h3>VIEWS</h3>
					<ul>
						<li><a title="Schema analysis" href="schema_analysis_views.html">Schema analysis</a></li>
						<li><a title="Data dimension" href="data_dimension_views.html">Data dimension</a></li>
						<li><a title="Process" href="process_views.html">Process</a></li>
						<li><a title="Security" href="security_views.html">Security</a></li>
						<li><a title="Monitoring" href="monitoring_views.html">Monitoring</a></li>
						<li><a title="InnoDB Plugin" href="innodb_plugin_views.html">InnoDB Plugin</a></li>
						<li><a title="Percona server" href="percona_server_views.html">Percona Server</a></li>
						<li><a title="TokuDB" href="tokudb_views.html">TokuDB</a></li>
					</ul>						
					<h3>DATA</h3>
					<ul>
						<li><a title="tables" href="tables.html">Tables</a></li>
						<li><a title="variables" href="variables.html">Variables</a></li>
					</ul>						
					<h3>META</h3>
					<ul>
						<li><a title="Help" href="help.html">help</a></li>
						<li><a title="Metadata" href="metadata.html">metadata</a></li>
						<li><a title="status" href="status.html">status</a></li>
					</ul>						
				</div>
			</div>	
			<div class="clear">&nbsp;</div>
			
			<div id="footnote" align="center">
				<a href="">common_schema</a> documentation
			</div>
		</div>
	</div>
</body>
</html>
